IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'boogaloo_core_entity_GetPublicComments_sp')
	BEGIN
		DROP  Procedure  boogaloo_core_entity_GetPublicComments_sp
	END

GO

CREATE Procedure [dbo].boogaloo_core_entity_GetPublicComments_sp
	(
		@entity_key			UNIQUEIDENTIFIER
	)
AS
/***********************************************
Author:		Rusty Swayne (rusty@mindfly.com)
Created:	7/23/2007
************************************************/
	SELECT	* 
	FROM	boogaloo_comment_tbl (NOLOCK) 
	WHERE	entity_key	= @entity_key
	AND		moderation_status IN ('a','r','n')
	ORDER
	BY		created_date ASC